<?php

$sql = array();

$sql[] = 'CREATE TABLE swixs_categories (
  category_id bigint(20) unsigned NOT NULL auto_increment,
  category_title varchar(255) collate utf8_unicode_ci NOT NULL,
  category_permissions longtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (category_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql[] = 'CREATE TABLE swixs_config (
  config_id bigint(20) unsigned NOT NULL auto_increment,
  config_title text collate utf8_unicode_ci NOT NULL,
  config_description longtext collate utf8_unicode_ci NOT NULL,
  config_key varchar(40) collate utf8_unicode_ci NOT NULL,
  config_val longtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (config_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql[] = 'CREATE TABLE swixs_forums (
  forum_id bigint(20) unsigned NOT NULL auto_increment,
  forum_parent bigint(20) unsigned NOT NULL,
  forum_title varchar(255) collate utf8_unicode_ci NOT NULL,
  forum_description text collate utf8_unicode_ci NOT NULL,
  forum_permissions longtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (forum_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql[] = 'CREATE TABLE swixs_posts (
  post_id bigint(20) unsigned NOT NULL auto_increment,
  post_parent bigint(20) unsigned NOT NULL,
  post_content longtext collate utf8_unicode_ci NOT NULL,
  post_author varchar(50) collate utf8_unicode_ci NOT NULL,
  post_post_date varchar(10) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (post_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql[] = 'CREATE TABLE swixs_style_sets (
  style_id bigint(20) NOT NULL auto_increment,
  style_name varchar(50) collate utf8_unicode_ci NOT NULL,
  style_author varchar(50) collate utf8_unicode_ci NOT NULL,
  style_website varchar(90) collate utf8_unicode_ci NOT NULL,
  style_css longtext collate utf8_unicode_ci NOT NULL,
  style_macros longtext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (style_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql[] = 'CREATE TABLE swixs_topics (
  topic_id bigint(20) unsigned NOT NULL auto_increment,
  topic_parent bigint(20) unsigned NOT NULL,
  topic_title varchar(150) collate utf8_unicode_ci NOT NULL,
  topic_content longtext collate utf8_unicode_ci NOT NULL,
  topic_author varchar(50) collate utf8_unicode_ci NOT NULL,
  topic_post_date varchar(10) collate utf8_unicode_ci NOT NULL,
  topic_views bigint(20) unsigned NOT NULL,
  topic_attributes varchar(20) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (topic_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';

$sql[] = 'CREATE TABLE swixs_users (
  user_id bigint(20) unsigned NOT NULL auto_increment,
  user_gid bigint(20) unsigned NOT NULL,
  user_username varchar(50) collate utf8_unicode_ci NOT NULL,
  user_password varchar(50) collate utf8_unicode_ci NOT NULL,
  user_usertitle varchar(50) collate utf8_unicode_ci NOT NULL,
  user_activation_key varchar(30) collate utf8_unicode_ci NOT NULL,
  user_join_date varchar(10) collate utf8_unicode_ci NOT NULL,
  user_last_visit varchar(10) collate utf8_unicode_ci NOT NULL,
  user_email varchar(100) collate utf8_unicode_ci NOT NULL,
  user_website varchar(100) collate utf8_unicode_ci NOT NULL,
  user_msn varchar(100) collate utf8_unicode_ci NOT NULL,
  user_aim varchar(100) collate utf8_unicode_ci NOT NULL,
  user_yahoo varchar(100) collate utf8_unicode_ci NOT NULL,
  user_skype varchar(100) collate utf8_unicode_ci NOT NULL,
  user_real_name varchar(40) collate utf8_unicode_ci NOT NULL,
  user_gender enum(\'male\',\'female\') collate utf8_unicode_ci NOT NULL,
  user_location varchar(100) collate utf8_unicode_ci NOT NULL,
  user_intrests text collate utf8_unicode_ci NOT NULL,
  user_avatar text collate utf8_unicode_ci NOT NULL,
  user_signature text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (user_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;';


?>